Edinburgh’s road network

Edinburgh’s implementation zones

Edinburgh’s control zones

Time series analysis

Mapping accidents with roads: 2013

##                    LAYER Accident_Index
## 1 20mph existing streets             48
## 2    20mph local streets             72
## 3     20mph main streets            182
## 4                  30mph             98
## 5                  40mph             43
## 6        50, 60 or 70mph              1
## 7        Part time 20mph              1
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20             25
## 2          30            387
## 3          40             35

Mapping accidents with roads: 2014

##                    LAYER Accident_Index
## 1 20mph existing streets            154
## 2    20mph local streets            158
## 3     20mph main streets            389
## 4                  30mph            266
## 5                  40mph             68
## 6        50, 60 or 70mph             14
## 7        Part time 20mph              9
## 8            Trunk roads              5
##   Speed_limit Accident_Index
## 1          20             39
## 2          30            955
## 3          40             69

Mapping accidents with roads: 2015

##                    LAYER Accident_Index
## 1 20mph existing streets            106
## 2    20mph local streets            156
## 3     20mph main streets            327
## 4                  30mph            254
## 5                  40mph             80
## 6        50, 60 or 70mph             12
## 7        Part time 20mph              6
## 8            Trunk roads              5
##   Speed_limit Accident_Index
## 1          20             34
## 2          30            832
## 3          40             80

Mapping accidents with roads: 2016

##                    LAYER Accident_Index
## 1 20mph existing streets             48
## 2    20mph local streets             57
## 3     20mph main streets             25
## 4                  30mph             28
## 5                  40mph             17
##   Speed_limit Accident_Index
## 1          20              8
## 2          30            148
## 3          40             19

Mapping accidents with roads: 2018

##                    LAYER Accident_Index
## 1 20mph existing streets             64
## 2    20mph local streets             83
## 3     20mph main streets            181
## 4                  30mph            146
## 5                  40mph             47
## 6        50, 60 or 70mph              5
## 7        Part time 20mph              7
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20            289
## 2          30            191
## 3          40             55

Mapping accidents with roads: 2019

##                    LAYER Accident_Index
## 1 20mph existing streets             31
## 2    20mph local streets             51
## 3     20mph main streets             88
## 4                  30mph             77
## 5                  40mph             24
## 6        50, 60 or 70mph              2
## 7        Part time 20mph              1
## 8            Trunk roads              1
##   Speed_limit Accident_Index
## 1          20            153
## 2          30             97
## 3          40             25

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            356
## 2    20mph local streets            443
## 3     20mph main streets            923
## 4                  30mph            646
## 5                  40mph            208
## 6        50, 60 or 70mph             27
## 7        Part time 20mph             16
## 8            Trunk roads             12
##   Speed_limit Accident_Index
## 1          20            106
## 2          30           2322
## 3          40            203

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets             95
## 2    20mph local streets            134
## 3     20mph main streets            269
## 4                  30mph            223
## 5                  40mph             71
## 6        50, 60 or 70mph              7
## 7        Part time 20mph              8
## 8            Trunk roads              3
##   Speed_limit Accident_Index
## 1          20            442
## 2          30            288
## 3          40             80

Output column: Layer

##     ID Speed_limit              LAYER
## 1 1509          30              30mph
## 2  987          30 20mph main streets
## 3 2505          30              30mph
## 4 1614          30              30mph
## 5 2355          30              30mph
## 6  153          30 20mph main streets

Table: Average annual road traffic collision rates in the city of Edinburgh (GIS)

Table 1: Average annual road traffic collision rates in the city of Edinburgh (GIS)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 30mph 646 223 215.33 223 7.67 4
Streets at 20mph 356 95 118.67 95 -23.67 -20
Streets at 30mph changed to 20mph 1366 403 455.33 403 -52.33 -11
Streets at 40mph 208 71 69.33 71 1.67 2
All streets 2576 792 858.67 792 -66.67 -8

Table: Average annual road traffic collision rates in the city of Edinburgh (Stats19)

Table 2: Average annual road traffic collision rates in the city of Edinburgh (Stats19)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 20mph 106 442 35.33 442 406.67 1151
Streets at 30mph 2322 288 774.00 288 -486.00 -63
Streets at 40mph 203 80 67.67 80 12.33 18
All streets 2631 810 877.00 810 -67.00 -8

Effect estimate (GIS)

Effect estimate(GIS)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 1054 966 611 810
Effect estimate -14.91

Effect estimate (Stats19)

Effect estimate(Stats19)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 1032 945 599 792
Effect estimate -14.76

Mapping accidents with implementation zones: 2013

##   ImplementationZone Accident_Index
## 1                  1             73
## 2                  2            105
## 3                  3            137
## 4                  4             44
## 5                  5             68
## 6                  6             30
## 7                  7             21

Mapping accidents with implementation zones: 2014

##   ImplementationZone Accident_Index
## 1                  1            168
## 2                  2            275
## 3                  3            298
## 4                  4            109
## 5                  5            132
## 6                  6             89
## 7                  7             58

Mapping accidents with implementation zones: 2015

##   ImplementationZone Accident_Index
## 1                  1            155
## 2                  2            210
## 3                  3            273
## 4                  4             75
## 5                  5            144
## 6                  6             91
## 7                  7             43

Mapping accidents with implementation zones: 2016

##   ImplementationZone Accident_Index
## 1                  1             96
## 2                  2            120
## 3                  3            147
## 4                  4             48
## 5                  5             60
## 6                  6             48
## 7                  7             24

Mapping accidents with implementation zones: 2018

##   ImplementationZone Accident_Index
## 1                  1             88
## 2                  2            125
## 3                  3            160
## 4                  4             53
## 5                  5             68
## 6                  6             46
## 7                  7             30

Mapping accidents with implementation zones: 2019

##   ImplementationZone Accident_Index
## 1                  1             42
## 2                  2             68
## 3                  3             79
## 4                  4             33
## 5                  5             27
## 6                  6             18
## 7                  7             14

Output column: Implementation Zone

##   Accident_Index Speed_limit ImplementationZone
## 1  2013950000001          30                  1
## 2  2013950000002          30                  2
## 3  2013950000003          30                  2
## 4  2013950000007          30                  1
## 5  2013950000010          30                  4
## 6  2013950000058          20                  7

Total accidents per zone

##   ImplementationZone Accident_Index
## 1                  1            622
## 2                  2            903
## 3                  3           1094
## 4                  4            362
## 5                  5            499
## 6                  6            322
## 7                  7            190

Control zone 1a:City center –> George St/Harbour, Aberdeen

## [1] 81

Control zone 1b:Rural west –> Tay Bridgehead & St Andrews

## [1] 60

Control zone 3:South central –> Dundee

## [1] 494

Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West

## [1] 286

Control zone 5:West –> Glasgow Kelvin

## [1] 977

Control zone 6:South –> Paisley

## [1] 391

Updated dataset for Edinburgh

##   Accident_Index Speed_limit               LAYER ImplementationZone
## 1        0000419          20  20mph main streets                  2
## 2        0000519          20 20mph local streets                  1
## 3        0000919          40 20mph local streets                  3
## 4        0001019          20               30mph                  2
## 5        0001219          40               40mph                  4
## 6        0001419          30               30mph                  4